Subqueries
Here are some sections in the PostgreSQL documentation that discuss other forms of subqueries:
Scalar Subqueries Subquery Expressions The FROM clause